package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;


public class UserinfoDemo {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {




       Class.forName("com.mysql.cj.jdbc.Driver");

       Connection connection = DriverManager.getConnection(
               "jdbc:mysql://localhost:3306/tedu?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true",
               "root",
               "root"
       );

        UserInfo userinfo = InputUtil.getInputObject(new UserInfo(), "欢迎注册");
        System.out.println(userinfo);

       Statement statement = connection.createStatement();// 创建执行SQL语句的对象

       String sql="insert into userinfo(username,password,nickname,age) " +
               "values ("+userinfo.getUsername()+","+userinfo.getPassword()+","+userinfo.getNickname()+","+userinfo.getAge()+");";

       int num = statement.executeUpdate(sql);//执行sql
       if(num>0){
           System.out.println("插入数据成功");
       }

       connection.close();

    }
}
